Join Multiple - How to get measure value of Master table when query Secondary columns

Hi Team,

Joined two tables with inner join and trying to get Measure value. While selecting secondary table with grouping in place but getting NULL values in Measure column. Please assist.

Master table:

WW8, RV_VARIANCE

00000258, 23,000,000 M

Secondary table:

DD1_WW_CUST_ACCT_NBR, DD1_WW_CUST_ACCT_NM , WW_CUST_ACCT_NBR

00000258, General Motors Corporation, 0000025828

Expectation:

DD1_WW_CUST_ACCT_NBR, DD1_WW_CUST_ACCT_NM , WW_CUST_ACCT_NBR, RV_VARIANCE

00000258, General Motors Corporation, 0000025828, 23,000,000 M

Please assist.

Thank You,

Abdulrasheed.

Screenshot 2024-01-16 212542.png

Developer Tools

Behavior Analysis

Accepted answers

TE271203

This issue resolved by using Find Replace tool instead of Join tool as the data granularity is causing data repentance.

Attached image for reference.

Thank You Team.

Screenshot 2024-01-18 160240.png

All comments

cjaneczko

Is your RV_VARIANCE a numeric field? I see commas and an M in there which looks like it may be a string field that has to be data cleansed first.

TE271203

Hi,

No, its a Measure value with Double data type. Just to notify that its a number, i have mentioned its M - Million at the end.

Sorry for the confusion.

Please assist.

Thank You,

Abdulrasheed.

TE271203

This issue resolved by using Find Replace tool instead of Join tool as the data granularity is causing data repentance.

Attached image for reference.

Thank You Team.

Screenshot 2024-01-18 160240.png

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703