help needed with Data issue after joining on an already loaded table

[fashid]

Hi,

In my application in the second tab. I have Loaded a billregister qvd.

In the second tab i have loaded the same table again but created a new field in it and joined the resulting table .

My issue is that the field HO does not get generated which i had created in the resident Load,

If I explicitly specify all the fields then the HO field get generated but the table data is not correct .

Please if anybody could help me out with this issue .

Regards

Nadeem

[sunny_talwar]

My issue is that the field HO does not get generated which i had created in the resident Load,

If I explicitly specify all the fields then the HO field get generated but the table data is not correct .

I am not sure I understand the above statement and that seems to be the crux of the matter. Would you be able to re-explain your requirement in another words?

Best,

Sunny

[sushil353 · Accepted solution]

Hi,

Instead of loading data again why don't you put condition in first time load itself to create HO Field as:

if(DATE(BILL_DATE,'DD/MM/YYYY')>=makedate(Year(today()),4),upper(if(trim(REGION)='IND' AND trim(CONTROLLER)='ACO','HO')),null()) AS HO

HTH

Sushil

[fashid]

Hi Sunny,

Thanks for replying 

If you go through the edit script in my  app in my main2 tab . I have loaded a qvd with the name BILLREGISTER.

In the main3 tab i have loaded the same qvd with change in the where clause and a new field with the field name HO.

.

When i am joining the two tables. I am getting wrong results.

I am attaching the screenshot also of the result.

[fashid]

AWESOME SUSHIL thats worked like a charm,

But i wanted to know why does my join not work correctly

Regards,

Nadeem

[fashid]

Hi,

Could anybody point out what the issue could be with the JOIN...