topic Re: expression in QlikView

expression

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

HI ,

I have 2 fields 1 is id, value

those 2 fields are having values are like below

ID, Value

1, a/b/c/d

BUt i want o/p like below

ID, value

1,a

2,b

3,c

4,d

How i can get the value?

Thanks in advance.

Re: expression

vinieme12 — Mon, 06 Feb 2017 11:29:45 GMT

are you guys from the same team??

the same query has been posted here

AUTOGENERATE

Re: expression

kaushiknsolanki — Mon, 06 Feb 2017 11:33:53 GMT

Hi,

Try this.

Data:

Load * inline [

ID, Value

1, a/b/c/d

];

Temp:

Load ID as ID1 , SubField(Value,'/') as Value Resident Data;

Drop table Data;

Final:

Load If(isnull(Previous(ID1)),ID1,(Peek(ID)+1)) as ID, Value Resident Temp;

Drop table Temp;

Regards,

Kaushik Solanki

Re: expression

sunny_talwar — Mon, 06 Feb 2017 12:27:29 GMT

Another options

Table:

LOAD RowNo() as ID,

SubField(Value, '/') as Value;

Load * inline [

ID, Value

1, a/b/c/d

];

Re: expression

sunny_talwar — Mon, 06 Feb 2017 12:28:08 GMT

It could very well be an interview question

Re: expression

vinieme12 — Mon, 06 Feb 2017 12:47:27 GMT

Lol

Re: expression

sunny_talwar — Mon, 06 Feb 2017 12:48:26 GMT

I am serious... I have seen people posting there interview question on the community....

Re: expression

vinieme12 — Mon, 06 Feb 2017 12:49:16 GMT

And question has been asked third time today, I think everyone is appearing for the same job

Re: expression

sunny_talwar — Mon, 06 Feb 2017 12:51:07 GMT

So if it is the third time... I am 99% sure it is for one of the interview.... But I guess if everyone answers it in the same way... it kind of defeats the purpose... How do you you choose? lol