/* * These styles apply ONLY to the header and footer assets. */ header { height: 60px; } @media screen and (max-width: 1100px) { header { display: none; } } .header__fixed-container { /*position: fixed;*/ width: 100%; z-index: 999; background: #ffffff; height: 60px; box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.2); min-width: 984px; /* TODO: revise when a responsive strategy for header is chosen */ } .header__content-container { display: flex; flex-direction: row; justify-content: space-between; margin: 0 auto; padding-right: 40px; } @media (max-width: 762px) { .header__content-container { padding-right: 20px; } } .header__left { display: flex; flex-direction: row; } .header__title-container { display: flex; flex-direction: column; justify-content: center; } .header__title { font-weight: 600; /* open sans semibold */ font-size: 14px; line-height: 24px; text-transform: uppercase; } .header__title-container { margin-left: 16px; } .header__subtitle { font-weight: 300; /* open sans light */ font-size: 20px; line-height: 24px; } .header__logo-container { background: #9ce; padding-top: 20px; padding-bottom: 20px; } .header__logo-image { width: 60px; } .header__right { display: flex; flex-direction: column; justify-content: center; } .header__nav__link-list { display: flex; flex-direction: row; list-style: none; font-size: 16px; line-height: 1.5; margin-right: -20px; } .header__nav__link-list-item { padding-left: 20px; padding-right: 20px; } .header__nav-link { text-decoration: none; color: inherit; } .header__nav-link:hover, .header__nav-link.current { /*color: #99ccee;*/ /* Darker to provide better contrast */ color: #5398c6; } * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #222222; min-height: 198px; padding: 50px 0; display: flex; flex-direction: column; justify-content: center; } .footer { color: #888888; font-size: 16px; line-height: 1.5; } .footer-wrap { width: 100%; max-width: 1224px; padding-left: 20px; padding-right: 20px; margin: 0 auto; } .footer-row { display: flex; flex-wrap: nowrap; justify-content: space-between; align-items: center; } .footer-col { display: inline-flex; } .footer__logo-container { height: 60px; /* margin-right: 40px; */ } .footer__logo-container img { height: 60px; } .footer__link-list { display: flex; flex-direction: row; list-style: none; text-align: center; font-weight: 400; } .footer__link-list-item { padding-left: 20px; padding-right: 20px; } .footer__link { text-decoration: none; color: inherit; } .footer__link:hover { color: #88bbdd; text-decoration: underline; } .footer__copyright-and-privacy-container { text-align: right; } @media screen and (max-width: 1100px) { .footer-row { flex-wrap: wrap; } .footer__link-list { flex-direction: column; line-height: 40px; } .footer-col { width: 100%; justify-content: center; } .footer-col:not(:last-of-type) { margin-bottom: 20px; } .footer__copyright-and-privacy-container { text-align: center; } } /*# sourceMappingURL=styles.css.map */

Help Center

Community

ETL

anasahmed

anasahmed ⚪️

March 17 edited March 17 in Dataflows

I have a column with multiple categories values, I want to convert this categories values to column labels. How do I do this. In the screenshot attached below I want to convert values of column '123 1' to column labels.

Tagged:

0

Answers

GrantSmith Indiana 🟣

March 17

Hi @anasahmed
You can use the pivot tile in a Magic ETL dataflow to convert your row values in your 123 1 column to actual columns.

1

or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!

Sign In Register

Categories

/* * These styles apply ONLY to the header and footer assets. */ header { height: 60px; } @media screen and (max-width: 1100px) { header { display: none; } } .header__fixed-container { /*position: fixed;*/ width: 100%; z-index: 999; background: #ffffff; height: 60px; box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.2); min-width: 984px; /* TODO: revise when a responsive strategy for header is chosen */ } .header__content-container { display: flex; flex-direction: row; justify-content: space-between; margin: 0 auto; padding-right: 40px; } @media (max-width: 762px) { .header__content-container { padding-right: 20px; } } .header__left { display: flex; flex-direction: row; } .header__title-container { display: flex; flex-direction: column; justify-content: center; } .header__title { font-weight: 600; /* open sans semibold */ font-size: 14px; line-height: 24px; text-transform: uppercase; } .header__title-container { margin-left: 16px; } .header__subtitle { font-weight: 300; /* open sans light */ font-size: 20px; line-height: 24px; } .header__logo-container { background: #9ce; padding-top: 20px; padding-bottom: 20px; } .header__logo-image { width: 60px; } .header__right { display: flex; flex-direction: column; justify-content: center; } .header__nav__link-list { display: flex; flex-direction: row; list-style: none; font-size: 16px; line-height: 1.5; margin-right: -20px; } .header__nav__link-list-item { padding-left: 20px; padding-right: 20px; } .header__nav-link { text-decoration: none; color: inherit; } .header__nav-link:hover, .header__nav-link.current { /*color: #99ccee;*/ /* Darker to provide better contrast */ color: #5398c6; } * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #222222; min-height: 198px; padding: 50px 0; display: flex; flex-direction: column; justify-content: center; } .footer { color: #888888; font-size: 16px; line-height: 1.5; } .footer-wrap { width: 100%; max-width: 1224px; padding-left: 20px; padding-right: 20px; margin: 0 auto; } .footer-row { display: flex; flex-wrap: nowrap; justify-content: space-between; align-items: center; } .footer-col { display: inline-flex; } .footer__logo-container { height: 60px; /* margin-right: 40px; */ } .footer__logo-container img { height: 60px; } .footer__link-list { display: flex; flex-direction: row; list-style: none; text-align: center; font-weight: 400; } .footer__link-list-item { padding-left: 20px; padding-right: 20px; } .footer__link { text-decoration: none; color: inherit; } .footer__link:hover { color: #88bbdd; text-decoration: underline; } .footer__copyright-and-privacy-container { text-align: right; } @media screen and (max-width: 1100px) { .footer-row { flex-wrap: wrap; } .footer__link-list { flex-direction: column; line-height: 40px; } .footer-col { width: 100%; justify-content: center; } .footer-col:not(:last-of-type) { margin-bottom: 20px; } .footer__copyright-and-privacy-container { text-align: center; } } /*# sourceMappingURL=styles.css.map */