If you're good at Alteryx, could you please help me?

[rively90]

Hi all,

I'm quite new to Alteryx and would like to know if someone can help guide me or provide examples to clean this dataset. This data is too hard to me to clean as I'm just a beginner.

I know that I need to combine all of the data from 2014 to 2021 into one. Should I pivot the data and do Vlook up? What should I do? Thank you for your time!

https://tinyurl.com/eeocdataset

Downloads

• Download 2021 EEO-1 Public Use File (PUF)
• Download 2020 EEO-1 Public Use File (PUF)
• Download 2019 EEO-1 Public Use File (PUF)
• Download 2018 EEO-1 Public Use File (PUF)
• Download 2017 EEO-1 Public Use File (PUF)
• Download 2016 EEO-1 Public Use File (PUF)
• Download 2015 EEO-1 Public Use File (PUF)
• Download 2014 EEO-1 Public Use File (PUF)

There are also some labels under page 6-12

• PUF User Guide
  
  Appendix 1 Variable Labels for the PUF Datasets
  Column Name Column Label
  NATION Label for National Level Geography
  REGION Label for Region Level Geography
  DIVISION Label for Division Level Geography
  STATE Label for State Level Geography
  CBSA Label for CBSA Level Geography
  COUNTY Label for County Level Geography
  NAICS2 Two-Digits Industry Code (Sector)
  NAICS2_Name Label for Two-Digits Industry Code
  NAICS3 Three-Digits Industry Codes (Subsector)
  NAICS3_Name Label for Three-Digits Industry Code
  Establishments Count of Establishments
  TOTAL10 Race: Aggregate, Sex: Aggregate, Job: Aggregate
  WHT10 Race: White, Sex: Aggregate, Job: Aggregate
  BLKT10 Race: Black or African American, Sex: Aggregate, Job: Aggregate
  HISPT10 Race: Hispanic, Sex: Aggregate, Job: Aggregate
  ASIANT10 Race: Asian, Sex: Aggregate, Job: Aggregate
  AIANT10 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Aggregate
  NHOPIT10 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Aggregate
  TOMRT10 Race: Two or more Races, Sex: Aggregate, Job: Aggregate
  MT10 Race: Aggregate, Sex: Male, Job: Aggregate
  FT10 Race: Aggregate, Sex: Female, Job: Aggregate
  TOTAL1 Race: Aggregate, Sex: Aggregate, Job: Senior Off and Managers
  TOTAL2 Race: Aggregate, Sex: Aggregate, Job: Professionals
  TOTAL3 Race: Aggregate, Sex: Aggregate, Job: Technicians
  TOTAL4 Race: Aggregate, Sex: Aggregate, Job: Sales Workers
  TOTAL5 Race: Aggregate, Sex: Aggregate, Job: Clericals
  TOTAL6 Race: Aggregate, Sex: Aggregate, Job: Craft
  TOTAL7 Race: Aggregate, Sex: Aggregate, Job: Operatives
  TOTAL8 Race: Aggregate, Sex: Aggregate, Job: Labors
  TOTAL9 Race: Aggregate, Sex: Aggregate, Job: Service
  TOTAL1_2 Race: Aggregate, Sex: Aggregate, Job: Mid Off and Managers
  WHM10 Race: White, Sex: Male, Job: Aggregate
  BLKM10 Race: Black or African American, Sex: Male, Job: Aggregate
  HISPM10 Race: Hispanic, Sex: Male, Job: Aggregate
  ASIANM10 Race: Asian, Sex: Male, Job: Aggregate
  AIANM10 Race: American Indian or Alaska Native, Sex: Male, Job: Aggregate
  NHOPIM10 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Aggregate
  NORC | The Equal Employment Opportunity Commission (EEOC)
  7
  TOMRM10 Race: Two or more Races, Sex: Male, Job: Aggregate
  WHF10 Race: White, Sex: Female, Job: Aggregate
  BLKF10 Race: Black or African American, Sex: Female, Job: Aggregate
  HISPF10 Race: Hispanic, Sex: Female, Job: Aggregate
  ASIANF10 Race: Asian, Sex: Female, Job: Aggregate
  AIANF10 Race: American Indian or Alaska Native, Sex: Female, Job: Aggregate
  NHOPIF10 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Aggregate
  TOMRF10 Race: Two or more Races, Sex: Female, Job: Aggregate
  WHT1 Race: White, Sex: Aggregate, Job: Senior Off and Managers
  WHT2 Race: White, Sex: Aggregate, Job: Professionals
  WHT3 Race: White, Sex: Aggregate, Job: Technicians
  WHT4 Race: White, Sex: Aggregate, Job: Sales Workers
  WHT5 Race: White, Sex: Aggregate, Job: Clericals
  WHT6 Race: White, Sex: Aggregate, Job: Craft
  WHT7 Race: White, Sex: Aggregate, Job: Operatives
  WHT8 Race: White, Sex: Aggregate, Job: Labors
  WHT9 Race: White, Sex: Aggregate, Job: Service
  WHT1_2 Race: White, Sex: Aggregate, Job: Mid Off and Managers
  BLKT1 Race: Black or African American, Sex: Aggregate, Job: Senior Off and Managers
  BLKT2 Race: Black or African American, Sex: Aggregate, Job: Professionals
  BLKT3 Race: Black or African American, Sex: Aggregate, Job: Technicians
  BLKT4 Race: Black or African American, Sex: Aggregate, Job: Sales Workers
  BLKT5 Race: Black or African American, Sex: Aggregate, Job: Clericals
  BLKT6 Race: Black or African American, Sex: Aggregate, Job: Craft
  BLKT7 Race: Black or African American, Sex: Aggregate, Job: Operatives
  BLKT8 Race: Black or African American, Sex: Aggregate, Job: Labors
  BLKT9 Race: Black or African American, Sex: Aggregate, Job: Service
  BLKT1_2 Race: Black or African American, Sex: Aggregate, Job: Mid Off and Managers
  HISPT1 Race: Hispanic, Sex: Aggregate, Job: Senior Off and Managers
  HISPT2 Race: Hispanic, Sex: Aggregate, Job: Professionals
  HISPT3 Race: Hispanic, Sex: Aggregate, Job: Technicians
  HISPT4 Race: Hispanic, Sex: Aggregate, Job: Sales Workers
  HISPT5 Race: Hispanic, Sex: Aggregate, Job: Clericals
  HISPT6 Race: Hispanic, Sex: Aggregate, Job: Craft
  HISPT7 Race: Hispanic, Sex: Aggregate, Job: Operatives
  HISPT8 Race: Hispanic, Sex: Aggregate, Job: Labors
  HISPT9 Race: Hispanic, Sex: Aggregate, Job: Service
  HISPT1_2 Race: Hispanic, Sex: Aggregate, Job: Mid Off and Managers
  ASIANT1 Race: Asian, Sex: Aggregate, Job: Senior Off and Managers
  ASIANT2 Race: Asian, Sex: Aggregate, Job: Professionals
  ASIANT3 Race: Asian, Sex: Aggregate, Job: Technicians
  NORC | The Equal Employment Opportunity Commission (EEOC)
  8
  ASIANT4 Race: Asian, Sex: Aggregate, Job: Sales Workers
  ASIANT5 Race: Asian, Sex: Aggregate, Job: Clericals
  ASIANT6 Race: Asian, Sex: Aggregate, Job: Craft
  ASIANT7 Race: Asian, Sex: Aggregate, Job: Operatives
  ASIANT8 Race: Asian, Sex: Aggregate, Job: Labors
  ASIANT9 Race: Asian, Sex: Aggregate, Job: Service
  ASIANT1_2 Race: Asian, Sex: Aggregate, Job: Mid Off and Managers
  AIANT1 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Senior Off and Managers
  AIANT2 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Professionals
  AIANT3 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Technicians
  AIANT4 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Sales Workers
  AIANT5 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Clericals
  AIANT6 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Craft
  AIANT7 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Operatives
  AIANT8 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Labors
  AIANT9 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Service
  AIANT1_2 Race: American Indian or Alaska Native, Sex: Aggregate, Job: Mid Off and Managers
  NHOPIT1 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Senior Off and Managers
  NHOPIT2 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Professionals
  NHOPIT3 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Technicians
  NHOPIT4 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Sales Workers
  NHOPIT5 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Clericals
  NHOPIT6 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Craft
  NHOPIT7 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Operatives
  NHOPIT8 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Labors
  NHOPIT9 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Service
  NHOPIT1_2 Race: Native Hawaiian or Other Pacific Islander, Sex: Aggregate, Job: Mid Off and Managers
  TOMRT1 Race: Two or more Races, Sex: Aggregate, Job: Senior Off and Managers
  TOMRT2 Race: Two or more Races, Sex: Aggregate, Job: Professionals
  TOMRT3 Race: Two or more Races, Sex: Aggregate, Job: Technicians
  TOMRT4 Race: Two or more Races, Sex: Aggregate, Job: Sales Workers
  TOMRT5 Race: Two or more Races, Sex: Aggregate, Job: Clericals
  TOMRT6 Race: Two or more Races, Sex: Aggregate, Job: Craft
  TOMRT7 Race: Two or more Races, Sex: Aggregate, Job: Operatives
  TOMRT8 Race: Two or more Races, Sex: Aggregate, Job: Labors
  TOMRT9 Race: Two or more Races, Sex: Aggregate, Job: Service
  TOMRT1_2 Race: Two or more Races, Sex: Aggregate, Job: Mid Off and Managers
  MT1 Race: Aggregate, Sex: Male, Job: Senior Off and Managers
  MT2 Race: Aggregate, Sex: Male, Job: Professionals
  MT3 Race: Aggregate, Sex: Male, Job: Technicians
  MT4 Race: Aggregate, Sex: Male, Job: Sales Workers
  NORC | The Equal Employment Opportunity Commission (EEOC)
  9
  MT5 Race: Aggregate, Sex: Male, Job: Clericals
  MT6 Race: Aggregate, Sex: Male, Job: Craft
  MT7 Race: Aggregate, Sex: Male, Job: Operatives
  MT8 Race: Aggregate, Sex: Male, Job: Labors
  MT9 Race: Aggregate, Sex: Male, Job: Service
  MT1_2 Race: Aggregate, Sex: Male, Job: Mid Off and Managers
  FT1 Race: Aggregate, Sex: Female, Job: Senior Off and Managers
  FT2 Race: Aggregate, Sex: Female, Job: Professionals
  FT3 Race: Aggregate, Sex: Female, Job: Technicians
  FT4 Race: Aggregate, Sex: Female, Job: Sales Workers
  FT5 Race: Aggregate, Sex: Female, Job: Clericals
  FT6 Race: Aggregate, Sex: Female, Job: Craft
  FT7 Race: Aggregate, Sex: Female, Job: Operatives
  FT8 Race: Aggregate, Sex: Female, Job: Labors
  FT9 Race: Aggregate, Sex: Female, Job: Service
  FT1_2 Race: Aggregate, Sex: Female, Job: Mid Off and Managers
  WHM1 Race: White, Sex: Male, Job: Senior Off and Managers
  BLKM1 Race: Black or African American, Sex: Male, Job: Senior Off and Managers
  HISPM1 Race: Hispanic, Sex: Male, Job: Senior Off and Managers
  ASIANM1 Race: Asian, Sex: Male, Job: Senior Off and Managers
  AIANM1 Race: American Indian or Alaska Native, Sex: Male, Job: Senior Off and Managers
  NHOPIM1 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Senior Off and Managers
  TOMRM1 Race: Two or more Races, Sex: Male, Job: Senior Off and Managers
  WHF1 Race: White, Sex: Female, Job: Senior Off and Managers
  BLKF1 Race: Black or African American, Sex: Female, Job: Senior Off and Managers
  HISPF1 Race: Hispanic, Sex: Female, Job: Senior Off and Managers
  ASIANF1 Race: Asian, Sex: Female, Job: Senior Off and Managers
  AIANF1 Race: American Indian or Alaska Native, Sex: Female, Job: Senior Off and Managers
  NHOPIF1 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Senior Off and Managers
  TOMRF1 Race: Two or more Races, Sex: Female, Job: Senior Off and Managers
  WHM2 Race: White, Sex: Male, Job: Professionals
  BLKM2 Race: Black or African American, Sex: Male, Job: Professionals
  HISPM2 Race: Hispanic, Sex: Male, Job: Professionals
  ASIANM2 Race: Asian, Sex: Male, Job: Professionals
  AIANM2 Race: American Indian or Alaska Native, Sex: Male, Job: Professionals
  NHOPIM2 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Professionals
  TOMRM2 Race: Two or more Races, Sex: Male, Job: Professionals
  WHF2 Race: White, Sex: Female, Job: Professionals
  BLKF2 Race: Black or African American, Sex: Female, Job: Professionals
  HISPF2 Race: Hispanic, Sex: Female, Job: Professionals
  ASIANF2 Race: Asian, Sex: Female, Job: Professionals
  NORC | The Equal Employment Opportunity Commission (EEOC)
  10
  AIANF2 Race: American Indian or Alaska Native, Sex: Female, Job: Professionals
  NHOPIF2 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Professionals
  TOMRF2 Race: Two or more Races, Sex: Female, Job: Professionals
  WHM3 Race: White, Sex: Male, Job: Technicians
  BLKM3 Race: Black or African American, Sex: Male, Job: Technicians
  HISPM3 Race: Hispanic, Sex: Male, Job: Technicians
  ASIANM3 Race: Asian, Sex: Male, Job: Technicians
  AIANM3 Race: American Indian or Alaska Native, Sex: Male, Job: Technicians
  NHOPIM3 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Technicians
  TOMRM3 Race: Two or more Races, Sex: Male, Job: Technicians
  WHF3 Race: White, Sex: Female, Job: Technicians
  BLKF3 Race: Black or African American, Sex: Female, Job: Technicians
  HISPF3 Race: Hispanic, Sex: Female, Job: Technicians
  ASIANF3 Race: Asian, Sex: Female, Job: Technicians
  AIANF3 Race: American Indian or Alaska Native, Sex: Female, Job: Technicians
  NHOPIF3 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Technicians
  TOMRF3 Race: Two or more Races, Sex: Female, Job: Technicians
  WHM4 Race: White, Sex: Male, Job: Sales Workers
  BLKM4 Race: Black or African American, Sex: Male, Job: Sales Workers
  HISPM4 Race: Hispanic, Sex: Male, Job: Sales Workers
  ASIANM4 Race: Asian, Sex: Male, Job: Sales Workers
  AIANM4 Race: American Indian or Alaska Native, Sex: Male, Job: Sales Workers
  NHOPIM4 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Sales Workers
  TOMRM4 Race: Two or more Races, Sex: Male, Job: Sales Workers
  WHF4 Race: White, Sex: Female, Job: Sales Workers
  BLKF4 Race: Black or African American, Sex: Female, Job: Sales Workers
  HISPF4 Race: Hispanic, Sex: Female, Job: Sales Workers
  ASIANF4 Race: Asian, Sex: Female, Job: Sales Workers
  AIANF4 Race: American Indian or Alaska Native, Sex: Female, Job: Sales Workers
  NHOPIF4 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Sales Workers
  TOMRF4 Race: Two or more Races, Sex: Female, Job: Sales Workers
  WHM5 Race: White, Sex: Male, Job: Clericals
  BLKM5 Race: Black or African American, Sex: Male, Job: Clericals
  HISPM5 Race: Hispanic, Sex: Male, Job: Clericals
  ASIANM5 Race: Asian, Sex: Male, Job: Clericals
  AIANM5 Race: American Indian or Alaska Native, Sex: Male, Job: Clericals
  NHOPIM5 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Clericals
  TOMRM5 Race: Two or more Races, Sex: Male, Job: Clericals
  WHF5 Race: White, Sex: Female, Job: Clericals
  BLKF5 Race: Black or African American, Sex: Female, Job: Clericals
  HISPF5 Race: Hispanic, Sex: Female, Job: Clericals
  NORC | The Equal Employment Opportunity Commission (EEOC)
  11
  ASIANF5 Race: Asian, Sex: Female, Job: Clericals
  AIANF5 Race: American Indian or Alaska Native, Sex: Female, Job: Clericals
  NHOPIF5 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Clericals
  TOMRF5 Race: Two or more Races, Sex: Female, Job: Clericals
  WHM6 Race: White, Sex: Male, Job: Craft
  BLKM6 Race: Black or African American, Sex: Male, Job: Craft
  HISPM6 Race: Hispanic, Sex: Male, Job: Craft
  ASIANM6 Race: Asian, Sex: Male, Job: Craft
  AIANM6 Race: American Indian or Alaska Native, Sex: Male, Job: Craft
  NHOPIM6 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Craft
  TOMRM6 Race: Two or more Races, Sex: Male, Job: Craft
  WHF6 Race: White, Sex: Female, Job: Craft
  BLKF6 Race: Black or African American, Sex: Female, Job: Craft
  HISPF6 Race: Hispanic, Sex: Female, Job: Craft
  ASIANF6 Race: Asian, Sex: Female, Job: Craft
  AIANF6 Race: American Indian or Alaska Native, Sex: Female, Job: Craft
  NHOPIF6 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Craft
  TOMRF6 Race: Two or more Races, Sex: Female, Job: Craft
  WHM7 Race: White, Sex: Male, Job: Operatives
  BLKM7 Race: Black or African American, Sex: Male, Job: Operatives
  HISPM7 Race: Hispanic, Sex: Male, Job: Operatives
  ASIANM7 Race: Asian, Sex: Male, Job: Operatives
  AIANM7 Race: American Indian or Alaska Native, Sex: Male, Job: Operatives
  NHOPIM7 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Operatives
  TOMRM7 Race: Two or more Races, Sex: Male, Job: Operatives
  WHF7 Race: White, Sex: Female, Job: Operatives
  BLKF7 Race: Black or African American, Sex: Female, Job: Operatives
  HISPF7 Race: Hispanic, Sex: Female, Job: Operatives
  ASIANF7 Race: Asian, Sex: Female, Job: Operatives
  AIANF7 Race: American Indian or Alaska Native, Sex: Female, Job: Operatives
  NHOPIF7 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Operatives
  TOMRF7 Race: Two or more Races, Sex: Female, Job: Operatives
  WHM8 Race: White, Sex: Male, Job: Labors
  BLKM8 Race: Black or African American, Sex: Male, Job: Labors
  HISPM8 Race: Hispanic, Sex: Male, Job: Labors
  ASIANM8 Race: Asian, Sex: Male, Job: Labors
  AIANM8 Race: American Indian or Alaska Native, Sex: Male, Job: Labors
  NHOPIM8 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Labors
  TOMRM8 Race: Two or more Races, Sex: Male, Job: Labors
  WHF8 Race: White, Sex: Female, Job: Labors
  BLKF8 Race: Black or African American, Sex: Female, Job: Labors
  NORC | The Equal Employment Opportunity Commission (EEOC)
  12
  HISPF8 Race: Hispanic, Sex: Female, Job: Labors
  ASIANF8 Race: Asian, Sex: Female, Job: Labors
  AIANF8 Race: American Indian or Alaska Native, Sex: Female, Job: Labors
  NHOPIF8 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Labors
  TOMRF8 Race: Two or more Races, Sex: Female, Job: Labors
  WHM9 Race: White, Sex: Male, Job: Service
  BLKM9 Race: Black or African American, Sex: Male, Job: Service
  HISPM9 Race: Hispanic, Sex: Male, Job: Service
  ASIANM9 Race: Asian, Sex: Male, Job: Service
  AIANM9 Race: American Indian or Alaska Native, Sex: Male, Job: Service
  NHOPIM9 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Service
  TOMRM9 Race: Two or more Races, Sex: Male, Job: Service
  WHF9 Race: White, Sex: Female, Job: Service
  BLKF9 Race: Black or African American, Sex: Female, Job: Service
  HISPF9 Race: Hispanic, Sex: Female, Job: Service
  ASIANF9 Race: Asian, Sex: Female, Job: Service
  AIANF9 Race: American Indian or Alaska Native, Sex: Female, Job: Service
  NHOPIF9 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Service
  TOMRF9 Race: Two or more Races, Sex: Female, Job: Service
  WHM1_2 Race: White, Sex: Male, Job: Mid Off and Managers
  BLKM1_2 Race: Black or African American, Sex: Male, Job: Mid Off and Managers
  HISPM1_2 Race: Hispanic, Sex: Male, Job: Mid Off and Managers
  ASIANM1_2 Race: Asian, Sex: Male, Job: Mid Off and Managers
  AIANM1_2 Race: American Indian or Alaska Native, Sex: Male, Job: Mid Off and Managers
  NHOPIM1_2 Race: Native Hawaiian or Other Pacific Islander, Sex: Male, Job: Mid Off and Managers
  TOMRM1_2 Race: Two or more Races, Sex: Male, Job: Mid Off and Managers
  WHF1_2 Race: White, Sex: Female, Job: Mid Off and Managers
  BLKF1_2 Race: Black or African American, Sex: Female, Job: Mid Off and Managers
  HISPF1_2 Race: Hispanic, Sex: Female, Job: Mid Off and Managers
  ASIANF1_2 Race: Asian, Sex: Female, Job: Mid Off and Managers
  AIANF1_2 Race: American Indian or Alaska Native, Sex: Female, Job: Mid Off and Managers
  NHOPIF1_2 Race: Native Hawaiian or Other Pacific Islander, Sex: Female, Job: Mid Off and Managers
  TOMRF1_2 Race: Two or more Races, Sex: Female, Job: Mid Off and Managers

[caltang]

That's a pretty big ask - let me see what I can do... The downloads for the data are quite slow, so please bear with me.

[caltang]

Please have a look. I've combined the datasets for you and cleansed the * in numeric values to be 0s, and changed the data type to Double.

Now, what else do you want to do with the data? That part is still a blur to me.

[caltang]

I've also compressed the data into YXDBs for easier usage. This is Part 1 due to limitations on what we can upload.

[caltang]

Part 2 of the YXDBs

[rively90]

Hi @caltang What should I do first? Thank you! What do you want me to clarify?

[rively90]

@caltang  I can't open yxdb file. what should I do?

[caltang]

You are not supposed to open the YXDB files, rather, you should use them as inputs in one folder location so that the workflow exported to you can work. Because the input method used is a Directory Tool, you need to do the following:

1. Download all the YXDBs into 1 folder which you can reference.
2. Download the YXZP file (Exported workflow), then double click it into Alteryx.
3. Click Yes to all and Import accordingly. 
4. Once imported, the workflow opens in Alteryx - now, hover to the left of the Canvas, and change the input location of the YXDBs to your own local path. Right now, that path is following where I stored the files.
5. Once changed, you can run the workflow and do what you want thereafter.

Kindly follow the steps above.

[caltang]

OK - What do you want to do with the data? What is it that you want to clean? Can you be clearer in your requirements?

Let me know what exactly you want to do with the data - then let me either build it for you or advise you how to build it.

[rively90]

@caltang  how do I add years here and eliminate some of the nulls?