FirstworkDate is not working when using Resident

[SatyaPaleti]

Hi Friends

I am using FirstworkDate function

My Issue is when I am directly Loading Data from Database and Using Firstworkdate function it's working fine but when I am using

By Resident Firstworkdate is not getting effect

Test:

LOAD Dates,

FirstWorkDate(Dates,8) as [TestDate]

FROM

xyz.qvw

Test2:

LOAD

FirstWorkDate(Dates,8) as [TestDate1]

Resident Test;

TestDate is working fine but TestDate1 is not getting Reflected

My Question is did Firstworkdate function will work when we using Resident??

Could Please help some one this Issue

Please find attached Sample Data and Sample qvw for More clarification

Thank you,

Satya

[sunny_talwar]

Did you forgot to link your two tables? Try this:

Test:

LOAD Dates,

FirstWorkDate(Dates,8) as [TestDate]

FROM

[Dates_Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Test2:

LOAD Dates,

FirstWorkDate(Dates,8) as [TestDate1]

Resident Test;

[SatyaPaleti]

Thank you So Much Sunny. Thats what I Expect

[sunny_talwar]

Awesome,

Please close this thread by marking the correct response if you are satisfied with it.

Best,

Sunny