topic Re: Split Collumn in QlikView

Split Collumn

YoussefKacem1 — Tue, 22 Nov 2022 11:00:14 GMT

Hello Everyone

I want to split Category Collumn into 3 Collumns (Goal , Penalty , Own Goal)

Thank you!

Bill_Britt — Tue, 22 Nov 2022 12:02:47 GMT

Hi,

You can do this with using Mid Function or Left function

table(mid(data,3,5)) as column name

for each new column

BrunPierre — Tue, 22 Nov 2022 12:05:23 GMT

Like this?

=Concat(Category ,' ,')