topic Re: Splitting a column into 2 separate columns in QlikView

Splitting a column into 2 separate columns

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

Hi,

I wanted to split a single column into 2 separate columns in the Script.

Logic:

One column which has field values which contains _H

and another Column which doesn't have _H.

Thanks,

Re: Splitting a column into 2 separate columns

vishsaggi — Thu, 14 Sep 2017 21:00:19 GMT

Try this?

IF(Index([End ID], '_H') = 6, [End ID]) AS NewField2,

IF(Index([End ID]', '_H') <> 6, [End ID]) AS NewField1

IF(FindOneOf(Replace([END ID], '_H', '@'), '@') > 0, [END ID]) AS NewField2,

IF(FindOneOf(Replace([END ID], '_H', '@'), '@') = 0, [END ID]) AS NewField1,

Re: Splitting a column into 2 separate columns

vvira1316 — Thu, 14 Sep 2017 21:06:28 GMT

See if this will help

Re: Splitting a column into 2 separate columns

trdandamudi — Thu, 14 Sep 2017 21:34:35 GMT

May be as below:

Load ID,
IF(Index(ID, '_H')>0, ID) AS [NewField-With H],
IF(Index(ID, '_H')=0, ID) AS [NewField2-Without H];
Load * Inline [
ID
B2700
B2800
B2700_H10
B2800_H10.1
];

Re: Splitting a column into 2 separate columns

satishqlik — Fri, 15 Sep 2017 05:27:56 GMT

May be something like this???

Output:

Re: Splitting a column into 2 separate columns

mostwanted123 — Fri, 15 Sep 2017 06:02:54 GMT

Try this,

if(wildmatch([End ID],'*_H*'),[End ID]) as EndID1,

if(not wildmatch([End ID],'*_H*'),[End ID]) as EndID2

Regards,

Pratik

Re: Splitting a column into 2 separate columns

Anonymous — Fri, 15 Sep 2017 07:47:27 GMT

Hi,

Try this:

Load ID,

IF(Index([End ID], '_H') = 6, Max([End ID])) AS NewField2,

IF(Index([End ID]', '_H') <> 6, Max([End ID])) AS NewField1

From Source

Group By ID

Adding the Max function and group by would ensure that the data is on the same line and therefore won't have multiple lines for each ID