Previous function help

[jpjust]

Hi Guys,

Hope some one can help me here. An critical one, any help will be greatly appreciated.

I have an qliksense table below.

Appname                             AppID                                Publish date                       Analyzed date

App1                                     12345                                   2012-12-15                          2012-12-14

App[1]                                  23456                                   Never                                     2012-12-15

Now the output I want is below, the second record from the above. instead of Never, I want the date from the App1 and the App[1] name should change to App1. Publish date should be current date. Is this possible?

Appname                             AppID                                Publish date                       Analyzed date

App 1                                    23456                                  2012-12-15                            2012-12-15

Thanks

[jpjust]

Hi Or - I am still struggling with this and I tried various ways but unable to achieve the desired results.

Here is my script:

[Script1]

LOAD 
[appId] as AppID,
[appName],
timestamp([createdDateTime]) as createdDateTime,
[flagCount]
RESIDENT RestConnectorMasterTable;

[Script2]

LOAD

[id_u3] AS AppID,
[name_u2] AS AppName,
if(left(publishTime,4)='1753','Never',date(timestamp(publishTime))) AS [App Publish Date]
RESIDENT RestConnectorMasterTable

Here is the output:

The output that I want is below:

Any help to achieve the above output will be appreciated.

Thanks