TO MAKE ONE COMMON DATE

[panipat1990]

Dear Team,

i stuck a requirement.i have one table where two date's fields. i want to make them a common date.How is possible.kindly help me for resolving this issue.for this i am sharing data.

In data two field delviery date and doc date. i want to make them one field this is common date(Link Date)

[panipat1990]

Still be waiting.

[MarcoWedel]

maybe you can create a common date field in your table like this (doubling the records!):

SET DateFormat='DD.MM.YYYY';

table1:
LOAD RecNo() as ID,
    [Doc. Date],
    [Del. Date],
    SubField([Doc. Date]&'@'&[Del. Date],'@') as Date,
    Purch.Doc.,
    Article,
    PGr,
    Item,
    Num#([Net price],'#,##,##,###.##') as [Net price],
    Num#(Quantity,'#,##,##,###.##') as Quantity,
    Num#([Net Value],'#,##,##,###.##') as [Net Value],
    Num#([GR Qty],'#,##,##,###.##') as [GR Qty]
FROM  (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

hope this helps

regards

Marco

[MarcoWedel · Accepted solution]

Glad you liked it.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco