Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
SK111
Contributor II
Contributor II

Regarding dual function

Hello Friends,

Appreciate your time. could you let me know the issue in the existing dual function below

store_Loop:
Load distinct  store_levels
resident store;
;


LET NumDFTables = NoOfRows('store_Loop');

for i=1 to $(NumDFTables)
Load dual ( i,j ) as str inline
[
i,j
1,A
2,B
3,C
4,D
5,E
6,F
7,G
8,H
9,I
10,
];

concatenate(Fact)
load distinct merchant&$(i) as  key
resident Fact;

I am trying to get merchant&A,merchant&B and so on as a key.,could you kindly let me know.,thank you!

 

Labels (1)
1 Reply
Vegar
MVP
MVP

You have swapped the parameters in the dual. Try this:

dual ( j,i ) as str