Spoon lookup obtaining two rows instead of duplicate columns
I have this two tables
If I use the lookup step using the EMPLOYEEID and YEAR I get this columns:
But I need to get this instead:
Solution
I have prepare a solution Here. Using this you will get your result.
Please let me know if its ok with you.
- AWS Glue Please verify role's TrustPolicy
- SSIS OLE DB Destination Editor - Create New Table not an option?
- Flattening a Recursive Hierarchy Into a Dimension with SSIS
- SSIS - the value cannot be converted because of a potential loss of data
- Getting an error : AttributeError: 'MySchemaClassName' object has no attribute "..type '' while working with apache_beam to_dataframe module
- SSIS tasks are getting fail with Communication link failure error
- Polars - Flatten rows into columns, aggregating by column values
- AWS glue to extract json referenced by id
- AWS Glue - o109.pyWriteDynamicFrame. ERROR: relation "xyz" already exists
- ETL Multiple Tables with relationships using Apache Nifi
- How to add a new Struct column to a DataFrame
- Running graph ops sequentially without affecting downstream
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- How to transfer "Set Variable" activity output into Json file using "Copy Data" activity or any other options?
- How do I pull the last modified file with data flow in azure data factory?
- What is the difference between AWS Glue ETL Job and AWS EMR?
- Expected String or bytes-like object, got 'float'
- Pyspark stream kafka debezium topic Error format, ETL
- Why is my SSIS toolbox empty in Visual Studio 2019 community?
- Errors with df.display() and df.show() in Databricks
- Error while trying to migrate data from one table to another in BigQuery
- How to find unique values from set of rows using pentaho kettle?
- Differences and Use Cases for Apache NiFi, Apache Airflow, and Apache Falcon?
- Unable to use both SQL Server and Postgres connection together on the same job - Talend
- SSIS How to get part of a string by separator
- JOLT shift transformation to filter values in array
- Pick the latest file based on datestamp provided in the filename
- Pass parameters from SQL Server Agent job to SSIS Package on Step "set value"
- How can I connect python to a database using sqlalchemy?
- Access to previous row in Kettle