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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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