Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have to join two tables based on string field. 'referral' and 'refprov'.
The referral has column 'refer_from' and refprov has 'rfocode'. When I use text(), the string '20' and '020' both turns to '020'.
But in reality they are separate physician code.
Data of refprov:
rfocode rfoname
20 Robert W
020 Sultan A
Data for referral:
refer_from referralnum
20 2842
result expected:
Table 1 View Table 2 view
referring Phy. Code ref.no.
Robert W 20 2842
This must be displayed in QlikSense sheet on table.
Can someone please guide me on what might be causing this? Is there any work around or am I missing anything?
Thanks.
Dear All,
I went through few articles and tried using Text function as per one of the suggestions here during QVD creation. I recreated everything from scratch and now it is working. Thank you here to everyone for your help. It was frustrating.
Take Care.