Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Have one requirement:
E.g:
the result should be 3
When comparing ID(Fact1) and Fact2.ID(Fact2) 3 records are not available in Fac2.
Fact1:
LOAD * INLINE [
Region, Country, ID
Asia, India, AsiaIndia
Asia, Singapore, AsiaSingapore
Asia, Malaysia, AsiaMalaysia
US, USA, USUSA
UK, London, UKLondon
East, Dubai, EastDubai
East, Saudi, EastSaudi
];
Qualify *;
Fact2:
LOAD * INLINE [
Region, Country, ID
Asia, India, AsiaIndia
Asia, Malaysia, AsiaMalaysia
US, USA, USUSA
UK, London, UKLondon
];
Pls find the attached sample app for reference.
Hi All
Tried using using Applymap() and was able to achieve the requirement
Hi All
Tried using using Applymap() and was able to achieve the requirement