Can someone very simply explain to me the formulas for cross tab and transpose pertaining to the amount of records in the output. For example the append tool is RECORDS x RECORDS since it’s a Cartesian join.

My understanding is transpose is rows x columns but I keep hearing conflicting info

Please any help on this would be greatly appreciated

Posting as :
works at
You are currently posting as works at

Related Posts

Anyone here regret pivoting from B4 management consulting to F500 Corporate Strategy? Specially CPG companies.

like

What’s the best area or suburb to live in Charlotte?

How is the final settlement calculated at Accenture? Notice period is 3 months.
Will I get normal monthly pay for the first two months? I'm leaving after completing 12 months.

like

Any recommendations on St Regis vs Ritz Carlton Istanbul?

like

Hi friends,

Please suggest which offer to choose

1) Fidelity Investment on PLSql (25 LPA)
2) Virtusa on Data Engineer role (not yet confirmed)

Having 9 years of total experience and I was basically a PLSQL developer.

Hi all!
My mother in law got scammed by a con artist from the UK online and lost $7K (damn you Facebook!)

Her status in the US is currently complicated and she doesn’t have a green card(tho she’s working on it), my wife(her daughter) is American.

I want to report this to the FBI’s elder fraud department but I don’t want to complicate her situation even more.

Does anyone know if criminal stuff like this and immigration related things are separated?

like

Hi everyone,

Anybody know about BAKER HUGHES company. Is it a product based or service based. ?
Can you share me how is it working with them ? How are growth opportunities, learning opportunities. Pros and Cons.. Anything would help. Thank you 😊

like

things to do in Vegas? favorite restaurants, hotels, spas, etc?

like

Has anyone ever been to the Alo Restaurant? I have never been there myself but I was wondering if this would be a good setting to propose?

like

Does your firm let you take 28-30 December off? Many of my team members won’t be working those days and I decided last minute that I’d like to travel somewhere between Christmas and the New Year.

likehelpful

My new Seamaster 😍

Post Photo
like

Looking for advice. I have a few offers in negotiations for Senior IT audit role. My main motive is to get out of toxic work culture in B4 consulting and public accounting. Looking for better wlb, better work culture and decent compensation to make good living. Currently in TX making around 110K TC.

1. Children’s Place: Base-110K . Probable bonus of 3-5%. No relocation assistance or sign on bonus. Based in NJ. Location is closer to all my friends and family
(Continued)

like

Got an offer as Senior Consultant 1 from CAPCO, earlier designation Sr Business Analyst. What is the growth perspective? Is it worth considering with 30% hike from current package?

like

DRS data: How many of you feel you are using your tech skills? Are you on C1 or C2 engagements? I'm on a staff-aug about to roll off & nervous the grass might not be greener & I'll be stuck in excel

Hello Fishes,

I joined CG on 27th July, the first project require me to work on documentation not related to my tech(networking) this I said no and went on bench.
The second project/client they tagged asking me to wrok on FTP L1 Monitoring and t-shoot.
Again this is not relevant to my exp(6 years in Network).

How to get released from this? the upper line is not in touch with me not they responding with update

What options do i have, what if I abscond?

Will they give me exp letter?

S&P Global Is it wise to join S&P Global during recession time? Can we consider this company as recession proof. Any history on layoffs in the past ..

S&P Global

Best resources for platform dev 1? I failed in 3 times and have to wait until spring. I’ve got 9 other certs(5 yoe) but this one is kicking my butt

like

How is the wlb at paytm noida, going to join as a Business Analyst-Senior associate and what is the salary range( have not finalised on this component with the HR)

like

Does your firm give you credit for hours that were written off? Sometimes I feel if you don’t lose anything for hours cut from the bill, you have incentives not to be 100% honest w/ your timesheet.

like

Firm announced flexible come and go as you see fit approach to coming back to office. Partner I work for said I need to be in office 4-5 days a week anyway. Thoughts?

likeuplifting

Additional Posts in Alteryx Professionals

Anyone here at Inspire?

Our audit team is looking for ideas on how to use Alteryx in our audit. I’m currently an authorized user of PowerBI, but would love to learn Alteryx. How have y’all used it, and did it gain efficiencies?

Anyone get the feeling that EY is pushing Power BI over Alteryx, even when Alteryx is a clearly better solution? Sometimes I wonder if it's related to license costs.

like

EY (specifically the New York FDD data analytics team) is actively hiring seniors and managers. Please feel free to reply to this post or send me a private message if interested. Thank you!

like

Anyone wants to take the expert certification exam?

like

What does Quick Connect do when connecting to databases when compared to picking a driver?

Would anyone mind explaining how the heck to edit a workflow that's saved as a .yxzp file? All of the zipped files get spat out after I open and import, and I don't understand how to package them up again 😥 I've already tried google so any guidance would be much appreciated!

like

Heavy Alteryx user here seeking new opportunities. Feel free to reach out.

like

Any idea if the Alteryx certifications provide CPE?

like

Looking for Senior Associates good in Alterx to join PwC's Tax Reporting & Strategy. You don't need to know tax. You can be remote. Please msg me if interested.

Is there anyone working at Macquarie bank in London?

How do you find out the SMTP settings at EY in order to use the Email tool in Alteryx?

EY’s Strategy and Transactions data analytics team (specifically NYC) is looking for staff and seniors to join our growing team! Drop a comment or msg me for more information / if you’re interested!

Analyticon has been rescheduled for January 2021

like

Any tips for self teaching?

Looking for some associates or senior associates proficient in Alteryx to join our team.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal