Forum Discussion
create 0 observations from multiple rows by column name
i have a table with data as below : Please help how can i do this scenario. places A001_Mango A011_orange A201_grapes Type ID Texas Available Available Oragnic fruit A0001 V...
Can you give examples of several months (3+) of column names? This can be fully dynamic, but we need to see the pattern
The column names contains like
month 1 - AMA00241_mangoes_raw, AMA01234_banana_raw,AMA04545_apples_raw, Type,ID,places
month2 - AMA03432_mangoes_ft, AMA01434_banana_ft,AMA04535_apples_ft, AMA09095_grapes_ft,AMA0005_pear_ft,Type,ID,places
month3 - AMA03345_peach_raw, AMA00034_orange_ft,Type,ID,places
The dynamic cloumn name contains like AMA0%