topic Re: Separate Merged Columns in Excel File in Load in QlikView

Separate Merged Columns in Excel File in Load

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

Is there a way to somehow separate two sets of data that exist in one cell in Excel?

Please see attached example; the numbers combined in one cell, separated by a slash. I only need the number on the right side of the slash. So in line 4 I want to keep 134 and not include 3 or anything to the left of 3.

Would be awesome if there was a solution for this.

Thanks everyone!

Re: Separate Merged Columns in Excel File in Load

vishsaggi — Wed, 30 May 2018 19:32:36 GMT

You can use Subfield() function.

Subfield(YourfieldName, '/', 2)

Re: Separate Merged Columns in Excel File in Load

qlikviewwizard — Thu, 31 May 2018 00:42:08 GMT

Hi,

I did not clear for which field you are looking for change.

Please check this.

='SubField Out Put :'&SubField(PNPUBA, '/', 2)

Re: Separate Merged Columns in Excel File in Load

oliveton — Thu, 31 May 2018 12:06:53 GMT

Oh sorry the field I was looking to change was "COMMN."

The SubField does seem to work! Thanks!