topic Re: Re: Using wildcards to load dimensions in QlikView

Using wildcards to load dimensions

Fri, 25 Oct 2013 05:55:12 GMT

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.

Re: Using wildcards to load dimensions

sujeetsingh — Fri, 25 Oct 2013 06:02:07 GMT

Can you provide a sample please

Re: Re: Using wildcards to load dimensions

Fri, 25 Oct 2013 06:28:08 GMT

here you go..

Re: Using wildcards to load dimensions

jagan — Fri, 25 Oct 2013 06:31:46 GMT

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.