Is there an alternative for the add constants tile?

pauljames
pauljames Contributor
in Magic ETL

Hi Everyone, I'm trying to establish a new column with the same value for every row. But instead of a manual floating decimal input through an add constants tile, I'd like to generate the value from the magic etl auto calculation every time the dataflow runs. I know there is a simple way to do this, but the solution escapes me…

The overall column value needs to be in every row for week of year.

Test1.PNG

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Have have you looked into doing a rank and window tile to calculate your number? That would then put it on each row

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Have have you looked into doing a rank and window tile to calculate your number? That would then put it on each row

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • pauljames
    pauljames Contributor

    How would you do that? I'm attempting without success.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • pauljames
    pauljames Contributor

    Hey I figured it out! Thanks Grant

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Categories