topic Re: help need in QlikView

help need

Thu, 12 Dec 2013 05:30:12 GMT

hi friends, i want to select 7 numbers among 8 number code.

ex: 08786543 so i want to select only 0878654 to compare to another table column values because it s code in 7digits. please help

LOAD BASE_PRICE as original_price,

CATALOG_NO as Item

FROM

(qvd);

here CATALOG_NO is in 8 digit code

LOAD [Item Number] AS Item

FROM

(qvd);

here [Item Number] is in 7 digit code

Re: help need

albertovarela — Thu, 12 Dec 2013 05:39:30 GMT

If it's the first 7 characters use this:

LOAD BASE_PRICE as original_price,

left(CATALOG_NO,7) as Item

FROM

(qvd);

Re: help need

Thu, 12 Dec 2013 05:43:34 GMT

Hi,

Might be smething like this:

LOAD BASE_PRICE as original_price,

Left(CATALOG_NO,7) as Item

FROM

(qvd);

And the second remais the same:

LOAD [Item Number] AS Item

FROM

(qvd);

But this is good when you want first 7 digit always.

Hope this helps!

Re: help need

Thu, 12 Dec 2013 05:47:05 GMT

thanks friends

Re: help need

Thu, 12 Dec 2013 05:51:28 GMT

Hi,

If you have got the solution, can you please close the thread by marking correct/helpful answer so it is easier for everyone to identify the solution.