date transformation

[0li5a3a]

Hello All,

I need your advise  regarding my new challenge. I have two column and I want to concatenate them but i don't want to concatenate all the information.

EX:

order                         date

12345                    12/10/2017

23654                    11/11/2016

I want to concatenate the column but I want to achieve this information : 12345121017( order+ DDMMYY).

I tried to convert the date from this format DD/MM/YYYY to DDMMYY but  with no success .

Thank you in advance!

[tresesco]

May be like:

order & Date(Date#(date, 'DD/MM/YYYY'), 'DDMMYY') as NewField

[el_aprendiz111]

Hi,

1 Example:

EX:
LOAD *,KeepChar(order & date,'0123456789') AS id_New;
LOAD * Inline
[
order,date
12345,12/10/2017
23654,11/11/2016
];
EXIT Script;

[0li5a3a]

Hi ,

Thanks your your answer but this doesn't works in my case scenario.

Thanks

[Peter_Cammaert]

Has your date column already been converted to a real QlikView date field? If so, please post an example document with actual data (a few rows is enough). All posted solutions work as expected on the example in your OP. So there may be something else in your actual data that is blocking a correct & efficient transformation using the smallest number of steps possible.

[ankit777]

Hi Use this

order&date(date,'DDMMYYYY')

thanks

[Anonymous]

Hi ,

Try this

=Order&date(Date,'MMDDYY')

[0li5a3a]

Thank you for your advise. I fixed my problem using txt files.

Is looking like if you try to concatenate 2 column from Excel document the concatenation doesn't concatenate right.

order & Date(Date#(date, 'DD/MM/YYYY'), 'DDMMYY') as NewField  this syntax is valid just in txt files not in excel.