Hi Team, @binu_acs Please assist on the below issue. want to get product ID based on Series_LG. i have applied join tool but cell data is truncated . Hence not able to get required results. Input Table A Product IDTV Series897935 (LG)76885352.1.9999(LG), 76885367.1.9999(LG), 76840736.1.9999(LG), 76885344.1.9999(LG), 76840734.1.9999(LG), 76872822.1.9999(LG)452772 (LG)76395965.1.9999(LG), 76336122.1.9999(LG), 76345238.1.9999(LG), 76336251.1.9999(LG), 76336258.1.9999(LG), 76336138.1.9999(LG), 76336189.1.9999(LG), 76421817.1.9999(LG)8645798 (LG)74921344.1.9999(LG), 74927964.1.9999(LG)9525088 (LG)76454312.1.9999(LG), 76454409.1.9999(LG), 76454533.1.9999(LG), 76454526.1.9999(LG), 76454130.1.9999(LG), 76454470.1.9999(LG), 76454259.1.9999(LG), 76454550.1.9999(LG), 76454186.1.9999(LG), 76454294.1.9999(LG), 76454413.1.9999(LG), 74880169.1.9999(LG), 76454146.1.9999(LG), 76454383.1.9999(LG), 76454320.1.9999(LG), 76454279.1.9999(LG), 76454476.1.9999(LG), 76489129.1.9999(LG), 74903119.1.9999(LG), 76454127.1.9999(LG), 76454267.1.9999(LG), 74879987.1.9999(LG), 76454195.1.9999(LG), 76454440.1.9999(LG), 76454258.1.9999(LG), 76454411.1.9999(LG), 76454225.1.9999(LG), 76454441.1.9999(LG), 76454390.1.9999(LG), 76454184.1.9999(LG), 76454439.1.9999(LG), 76454281.1.9999(LG), 76454227.1.9999(LG), 76454516.1.9999(LG), 76454252.1.9999(LG), 76454311.1.9999(LG), 76454329.1.9999(LG), 76454341.1.9999(LG), 76454255.1.9999(LG), 76454438.1.9999(LG), 76454306.1.9999(LG), 76454351.1.9999(LG), 76454432.1.9999(LG), 76454429.1.9999(LG), 76454396.1.9999(LG), 76454346.1.9999(LG), 76454430.1.9999(LG), 76454340.1.9999(LG), 76454448.1.9999(LG), 76454389.1.9999(LG), 76454168.1.9999(LG), 76454307.1.9999(LG), 76464377.1.9999(LG), 76454449.1.9999(LG), 76454347.1.9999(LG), 76454313.1.9999(LG), 76454386.1.9999(LG), 76454524.1.9999(LG), 76454423.1.9999(LG), 76454479.1.9999(LG), 76454385.1.9999(LG), 76454464.1.9999(LG), 76454182.1.9999(LG), 748874.1.9999(LG), 76454202.1.9999(LG), 74879999.1.9999(LG), 76454387.1.9999(LG), 76454404.1.9999(LG), 76454218.1.9999(LG), 76454143.1.9999(LG), 748832.1.9999(LG), 748843.1.9999(LG), 76454328.1.9999(LG), 76454380.1.9999(LG), 76454224.1.9999(LG), 76454382.1.9999(LG), 76454491.1.9999(LG), 76454278.1.9999(LG)198999750 (LG)75910119.1.9999(LG), 75926632.1.9999(LG), 75910387.1.9999(LG), 75909933.1.9999(LG), 75910112.1.9999(LG), 759117.1.9999(LG), 75910143.1.9999(LG), 75910250.1.9999(LG), 75909985.1.9999(LG) Table-BSeries_LG007684073600764218170074921344 0076454168 0075909985 Required OUTPUT: Output Series_LGProduct ID7684073689793576421817452772749213448645798 76454168 9525088 759099858999750

How to resolve truncate issue and get required product id by joining two tables

Anjankumar2021

Hi Team,

Please assist on the below issue.

want to get product ID based on Series_LG. i have applied join tool but cell data is truncated . Hence not able to get required results.

Input
Table A
Product ID	TV Series
897935 (LG)	76885352.1.9999(LG), 76885367.1.9999(LG), 76840736.1.9999(LG), 76885344.1.9999(LG), 76840734.1.9999(LG), 76872822.1.9999(LG)
452772 (LG)	76395965.1.9999(LG), 76336122.1.9999(LG), 76345238.1.9999(LG), 76336251.1.9999(LG), 76336258.1.9999(LG), 76336138.1.9999(LG), 76336189.1.9999(LG), 76421817.1.9999(LG)
8645798 (LG)	74921344.1.9999(LG), 74927964.1.9999(LG)
9525088 (LG)	76454312.1.9999(LG), 76454409.1.9999(LG), 76454533.1.9999(LG), 76454526.1.9999(LG), 76454130.1.9999(LG), 76454470.1.9999(LG), 76454259.1.9999(LG), 76454550.1.9999(LG), 76454186.1.9999(LG), 76454294.1.9999(LG), 76454413.1.9999(LG), 74880169.1.9999(LG), 76454146.1.9999(LG), 76454383.1.9999(LG), 76454320.1.9999(LG), 76454279.1.9999(LG), 76454476.1.9999(LG), 76489129.1.9999(LG), 74903119.1.9999(LG), 76454127.1.9999(LG), 76454267.1.9999(LG), 74879987.1.9999(LG), 76454195.1.9999(LG), 76454440.1.9999(LG), 76454258.1.9999(LG), 76454411.1.9999(LG), 76454225.1.9999(LG), 76454441.1.9999(LG), 76454390.1.9999(LG), 76454184.1.9999(LG), 76454439.1.9999(LG), 76454281.1.9999(LG), 76454227.1.9999(LG), 76454516.1.9999(LG), 76454252.1.9999(LG), 76454311.1.9999(LG), 76454329.1.9999(LG), 76454341.1.9999(LG), 76454255.1.9999(LG), 76454438.1.9999(LG), 76454306.1.9999(LG), 76454351.1.9999(LG), 76454432.1.9999(LG), 76454429.1.9999(LG), 76454396.1.9999(LG), 76454346.1.9999(LG), 76454430.1.9999(LG), 76454340.1.9999(LG), 76454448.1.9999(LG), 76454389.1.9999(LG), 76454168.1.9999(LG), 76454307.1.9999(LG), 76464377.1.9999(LG), 76454449.1.9999(LG), 76454347.1.9999(LG), 76454313.1.9999(LG), 76454386.1.9999(LG), 76454524.1.9999(LG), 76454423.1.9999(LG), 76454479.1.9999(LG), 76454385.1.9999(LG), 76454464.1.9999(LG), 76454182.1.9999(LG), 748874.1.9999(LG), 76454202.1.9999(LG), 74879999.1.9999(LG), 76454387.1.9999(LG), 76454404.1.9999(LG), 76454218.1.9999(LG), 76454143.1.9999(LG), 748832.1.9999(LG), 748843.1.9999(LG), 76454328.1.9999(LG), 76454380.1.9999(LG), 76454224.1.9999(LG), 76454382.1.9999(LG), 76454491.1.9999(LG), 76454278.1.9999(LG)
198999750 (LG)	75910119.1.9999(LG), 75926632.1.9999(LG), 75910387.1.9999(LG), 75909933.1.9999(LG), 75910112.1.9999(LG), 759117.1.9999(LG), 75910143.1.9999(LG), 75910250.1.9999(LG), 75909985.1.9999(LG)

Table-B
Series_LG
0076840736
0076421817
0074921344
0076454168
0075909985

Required OUTPUT:

Output
Series_LG	Product ID
76840736	897935
76421817	452772
74921344	8645798
76454168	9525088
75909985	8999750

Workflow

Accepted answers

binu_acs

@Anjankumar2021 use the find and replace tool or join tool,

TV Series_29052025.yxmd

All comments

apathetichell

I'd recommend going through on the online Alteryx trainings. Start from the beginning. To solve your issues - you'll split tv series to rows (probably /n as a delimeter) and then you'll clean your data so that you remove the leading 0's in one data source and everything after the . in the other... you can use regex.

you can then join.

Anjankumar2021

I have applied text to column with delimiter but not able to get required result for TV Series. after applying delimiter except first line in the cell "76885352"remaining got truncated in the Cell. Hence i got below output

Series_LG	Product ID
76840736
76421817
74921344	8645798
76454168
75909985

binu_acs

@Anjankumar2021 use the find and replace tool or join tool,

TV Series_29052025.yxmd

Anjankumar2021

@binu_acs thanks for your reply.

i want to include if Series _LG not found for respective product ID.

in this case i need to use Join tool instead of find and replace.

kindly assist

binu_acs

@Anjankumar2021, it should display as a null value in the Find and Replace tool. are you not seeing it?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703