Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have a table having three columns. Two columns having data type 'date' and third column is 'id'. I want to use the function NetworkDays on this two date columns and applying constraint on third column id. Is there any work around to achieve this.
Equivalent sql :- select date_diff(col1,col2) where id = "Error".
Thanks in advance
Hi,
Try like this
Load
id,
col1,
col2,
NetworkDays(col2,col1) as datediff
Resident TableName where id='Error';
Hope this helps
Celambarasan
Hi
I have four different type of ids so I would have to add four load statements. I don’t think it would be great for my qlikview data load.
Actually I wanted to achieve this in expressions. Is there any idea you can give to me.
Thanks & Regards
Tribhuwan
Hi,
Then you go with the if .
Load
id,
col1,
col2,
if(id='Error',NetworkDays(col2,col1)) as datediff
Resident TableName;
Celambarasan
Hi
id,col1, col2 are coming from three different tables. Can you please provide me the syntax of join.
Thanks & Regards
Tribhuwan
Hi,
Can you provide me the structure of your three tables?
Celambarasan
Hi
I need more information from development team. I will get back to you after getting this info.
Thanks for your valuable time and help
Thanks & Regards
Tribhuwan