Discussion Board for collaboration related to QlikView App Development.
is it possible to use some kind of wildcard to "find" dimensions?
My source file happens to include more than one column with the same description
What Qlikview does is it loads each dimension separately and puts a number on everyone:
workstep1, operation1, workstep2, operation2 ... thats not what i want.
I want it to put all workstep values together in 1 dimension calles workstep. I think you get what i mean..
Is there a way to do this automated?
I know i could do something like:
concatenate Load workstep1 as workstep resident blabla;
concatenate load workstep2 as workstep resident blabla;
and so on.
My question here is: Can i use something like
concatenate load workstep* as workstep resident blabla;
Reason behind this is that i do not know how many columns with the same name there are in the files i load.
Thank you in advance, i hope it's understandable.
Can you provide a sample please
here you go..
Try like this
CrossTable(Type, Data)LOAD RowNo() AS Numb,* INLINE [ WorkStep, Operation, WorkStep, Operation, WorkStep, Operation1, 4, 7, 10, 13, 162, 5, 8, 11, 14, 173, 6, 9, 12, 15, 18];DROP Field Numb;Data:NoConcatenateLOAD*RESIDENT DataTempWHERE Type = 'WorkStep';Drop table DataTemp;