Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Using wildcards to load dimensions

   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:

workstepoperation
workstep
operation
....
4213412grwewe421nsaaer....
32132asdasd566blabla...

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.

3 Replies
Highlighted
Master III
Master III

Re: Using wildcards to load dimensions

Can you provide a sample please

Highlighted
Not applicable

Re: Re: Using wildcards to load dimensions

here you go..

Highlighted
MVP & Luminary
MVP & Luminary

Re: Using wildcards to load dimensions

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.