Hi everyone,

I've created a Job that reads an Excel file and pivots some columns to rows. So far so good.
This is the Excel file:

Even though I'm using a dynamic schema (*) to read the file, I still have to know the real schema of the file so that I can configure the tExtractDynamicFields component correctly:

Then I use the tUnpivotRow component like this (because these columns are always constant):

And I get the desired result:

Thus far all is good.
The problem starts when I start getting Excel files with different schemas (mind you, the first 3 columns are always the same: Name, Surname, City).
(*) This is why I'm using the dynamic schema to read the Excel file.
How do I work with these files? How do I make my Job ready for any Excel that comes with a different schema than the one I'm using in this Job? 

Thank you,
Rui

Hi all,

Sorry for the newbie question. I would like to share a bookmark of a published dashboard so that other users can see my selection directly.

From the explanatory video, I see that after creating the bookmark there should be the option "Copy link" by clicking on the label of the bookmark.

However, in my case, this option does not exist. 

Any suggestion on what I am doing wrong?

Thanks!

Hello,

We have a Full load + Store changes task which loads data from Oracle to ADLS(parquet snappy format). But it is failing for one table during Full load with the error:

We have an OEM deployment of Qlik SaaS, using an IdP and whenever user's login for the first time they get this ridiculous questionnaire/prompt

The prompt:

1. Cant be closed without answering the questions

2. Asks questions that most business users don't know the answers to

3. Makes it a nightmare for a neat, nice user onboarding experience

Why can't this be disabled? ESPECIALLY for tenants that are OEM/managed by a 3rd party

Getting very frustrated at all the changes Qlik have been making with Cloud and this just makes it even worse....How did something like this get past Qlik UX testing? Understand the information provided could be useful for internal analytics but it frustrates the users (and admins of the product) - if the goal is to get Qlik Cloud to be an enterprise product (just like SaaS client-managed) take a look at how this affects sysadmins

I built an expression to find all dates in the next two weeks, but it also shows dates in the past. How can I update my expression to remove the dates in the past 

this is my expresison (its on a button)

='<=' & Date(Today()+7, 'YYYY-MMM-DD')

Following the documentation for editing users in the qlik-cli we are getting errors when attempting to edit a user

https://qlik.dev/toolkits/qlik-cli/user/user-edit/

We've tried a bunch of different variations for changing the user email address so we can migrate to a new identity provider.

//If we enter 
qlik user edit <userid>

//then a notepad window pops up and with the user content
//which we can edit without issue but the help for the command 
//shows how to use a --body flag but no matter how we code 
//that one we get an error saying that the flag --body does
//not exist



//Here is the text from the command help



qlik user edit <userId> --body '[{"op":"replace","path":"/name","value":<value>}]'

Does anybody have any suggestion for this syntax 

Hello Everyone,

I need help of writing script of creating unique key of 4 columns from 2 tables. please help me at earliest 

-----------************----------------------

LIB CONNECT TO 'DATABASE';

[TABLE 1] :

Load 

Column 1 as AA

Column 2 as BB

Column 3 as CC;

SQL SELECT "Column 1", "Column 2", "Column 3" FROM DATABASE Table;

[TABLE 2] :

Load 

Column X as XX

Column Y as YY

Column Z as ZZ;

SQL SELECT "Column X", "Column Y", "Column Z" FROM DATABASE Table;

Please help me what should I add in the script to create another table or add in any of the above table where I can make unique key as below.

CONCATENATE: Column Name: UNIQUEKEYADDR = AA&'-'&BB&'-'&XX'-'&YY

Please help me at earliest !!