Hi I have following data sets, initially we are mapping with session 1 with session columns and session 2 with session again , we unable to get the expected output. expected output USERSESSIONS.NOSWATHIWWW1SWATHIWXY1SWATHIWWW1SWETHAXXX2SWETHAXYZ2 dataset -1 USERSESSIONSWATHIWWWSWATHIWXYSWETHAXXXSWETHAXYZSWATHIWWWSWAPNAZZZSWAPNAXYZ dataset - 2 S.NOSESSION1SESSION21WWWWXY2WWWWZO3XXXXYZ4ZXOZZZ

Mapping Issue

I have following data sets, initially we are mapping with session 1 with session columns and session 2 with session again , we unable to get the expected output.

expected output

USER	SESSION	S.NO
SWATHI	WWW	1
SWATHI	WXY	1
SWATHI	WWW	1
SWETHA	XXX	2
SWETHA	XYZ	2

dataset -1

USER	SESSION
SWATHI	WWW
SWATHI	WXY
SWETHA	XXX
SWETHA	XYZ
SWATHI	WWW
SWAPNA	ZZZ
SWAPNA	XYZ

dataset - 2

S.NO	SESSION1	SESSION2
1	WWW	WXY
2	WWW	WZO
3	XXX	XYZ
4	ZXO	ZZZ

Data Investigation

Accepted answers

Christina_H

It looks like you're treating each group of rows separately, regardless of whether the same user appears again later. I've updated my solution from above to account for that.

Mapping.yxmd

All comments

ShankerV

Hi @BRRLL99

What is the logic to get the expected output.

If so and so, give me this result?

Many thanks

Shanker V

Christina_H

Is this what you're going for?

Mapping.yxmd

BRRLL99

One user may have have multiple sessions, based on user name we need to map session with session1 and session 2 and adding S.NO column to Table1

output should be dynamic.

We are trying to map session1 and session2 with session column of table1 for each user

EXPECTED OUTPUT

USER	SESSION	S.NO
SWATHI	WWW	1
SWATHI	WXY	1
SWATHI	WWW	1
SWETHA	XXX	2
SWETHA	XYZ	2
SWATHI	ABC	7
SWATHI	CBA	7

TABLE 1

USER SESSION

SWATHI	WWW
SWATHI	WXY
SWETHA	XXX
SWETHA	XYZ
SWATHI	WWW
SWAPNA	ZZZ
SWAPNA	XYZ
SWATHI	ABC
SWATHI	CBA

TABLE2

S.NO SESSION1 SESSION2

1	WWW	WXY
2	WWW	WZO
3	XXX	XYZ
4	ZXO	ZZZ
7	ABC	CBA

binu_acs

@BRRLL99 Any reason why the records for SWAPNA were not included in the output file? Also how SWETHA is mapped to SNO 2 instead of 3?

BRRLL99

SWAPNA Not mapping with the any paired sessions of table2,session column of table1 should map with the paired sessions(Session1, Session2) of table2.

Sorry My bad, SWETHA should have S.NO3

expected output

USER	SESSION	S.NO
SWATHI	WWW	1
SWATHI	WXY	1
SWATHI	WWW	1
SWETHA	XXX	3
SWETHA	XYZ	3
SWATHI	ABC	7
SWATHI	CBA	7

Christina_H

It looks like you're treating each group of rows separately, regardless of whether the same user appears again later. I've updated my solution from above to account for that.

Mapping.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703