Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kimboqlik
Contributor II
Contributor II

Loas as Statement

Created a connection and loaded the script. I would like insight into loading an as statement. There is already one in my script and it gives me the error that values have to be unique. Please share some background on load as statements. 

Example 

if(wildmatch - the table name - the wildmatch I want - as "new table name" But I am unable to add all of my wildmatches into the new table. I would like these exceptions or wildmatches to have their own table! 

Reason why it seems I need it in the script is because when I added the if wildmatch statement it only let me choose 2 variables. I have a list of 20.

Please shed some light!

Thank you.

 

Labels (2)
3 Replies
Lisa_P
Employee
Employee

Can you send some script sample ?

kimboqlik
Contributor II
Contributor II
Author

Hi,
Thank you for responding. I sent an example above. Can you please give me
some pointers to load as statements.

What I want to do is load say category is restaurant and in that category
there are several that I want to include in a new as statement.

So load restaurants "x" "y" "z" as restaurants 2
Lisa_P
Employee
Employee

I'm still a bit confused on your requirement