Using wildcards to load dimensions

[#1]

   Hello everyone,

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

example:

workstep	operation	workstep	operation	....
4213412	grwewe	421	nsaaer	....
32132	asdasd	566	blabla	...

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.

[sujeetsingh]

Can you provide a sample please

[#3]

here you go..

[jagan]

Hi,

Try like this

DataTemp:

CrossTable(Type, Data)
LOAD
RowNo() AS Numb,
*
INLINE [
WorkStep, Operation, WorkStep, Operation, WorkStep, Operation
1, 4, 7, 10, 13, 16
2, 5, 8, 11, 14, 17
3, 6, 9, 12, 15, 18
];
DROP Field Numb;
Data:
NoConcatenate
LOAD
*
RESIDENT DataTemp
WHERE Type = 'WorkStep';
Drop table DataTemp;

Regards,

Jagan.