Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Appreciate your time. could you let me know the issue in the existing dual function below
store_Loop:Load distinct store_levelsresident store;;
LET NumDFTables = NoOfRows('store_Loop');
for i=1 to $(NumDFTables) Load dual ( i,j ) as str inline[ i,j1,A2,B3,C4,D5,E6,F7,G8,H9,I10, ];
concatenate(Fact)load distinct merchant&$(i) as keyresident Fact;
I am trying to get merchant&A,merchant&B and so on as a key.,could you kindly let me know.,thank you!
You have swapped the parameters in the dual. Try this:
dual ( j,i ) as str